UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ddhyIEPnwBJqoi2t72VnYAWzA/kPAkbITkDygy2OmsM='
WHERE
key_id = '3e123a591dc8321bfdcca8a0c3994d2bac6b1fa4b4886b9683e41cc702030afc'
AND (
token = 'ddhyIEPnwBJqoi2t72VnYAWzA/kPAkbITkDygy2OmsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)