UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bb7ieOlG0qEgsDlg6nLGKBxq4BmuBt01eBMauVf2G7k='
WHERE
key_id = '09cba97d1ad81e69f2eaa5bd641659c8de8aef0b15c90217609a99f05b44bace'
AND (
token = 'bb7ieOlG0qEgsDlg6nLGKBxq4BmuBt01eBMauVf2G7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)