UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2f8NyHf+JhGITnmUzJHViBzvK5ta0F0NhNnZq+tMFls='
WHERE
key_id = '5f4a849e681ddcadfc8931aa0f219e13db499a9f10b4cef9f20bb96b13faab54'
AND (
token = '2f8NyHf+JhGITnmUzJHViBzvK5ta0F0NhNnZq+tMFls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)