UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FxW57VEHwWLMk7pfLiHINaHYlj64ClXzbbR2E4Uuaig='
WHERE
key_id = '5e4b019c2052b2438b241231a527548a1697b0b994a8ac3d3932d13966be50c9'
AND (
token = 'FxW57VEHwWLMk7pfLiHINaHYlj64ClXzbbR2E4Uuaig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)