UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0k4KmJWs/QlZHUI73ImNcXOC48iTwEwzuvM7rJU99WQ='
WHERE
key_id = 'a5e1cd55958743115fcc906c13069053bea8fb4f39744b5d7860111c0897987a'
AND (
token = '0k4KmJWs/QlZHUI73ImNcXOC48iTwEwzuvM7rJU99WQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)