UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cFiSgxIvGwDrRu3obxxJffDpYSdnjcDm/k685IlV9pM='
WHERE
key_id = '55c18225ef312c9c27caae9b50f85840bec2d8f7c7594c3620a55f8942e5dd85'
AND (
token = 'cFiSgxIvGwDrRu3obxxJffDpYSdnjcDm/k685IlV9pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)