UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hWs+zcfHxz+80R3WHFds/eJRu5djdPsJok61rTTNXYc='
WHERE
key_id = '1b71f9249d5f7c714b9b9e2ee95723a0905d2c1c39dc380cea7307b558977692'
AND (
token = 'hWs+zcfHxz+80R3WHFds/eJRu5djdPsJok61rTTNXYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)