UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xhq8DgjlbP/ojE6m+1P7f7+esG1n5m3wAVmU+yNl3S0='
WHERE
key_id = '3f354c9ace75799f4bb38cd923f66f36bbedf4f981961c15018f60d14209238a'
AND (
token = 'Xhq8DgjlbP/ojE6m+1P7f7+esG1n5m3wAVmU+yNl3S0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)